package com.hw.paltfrom.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.hw.paltfrom.pojo.HwCaseFile;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 李俊君
 * @since 2019-11-15
 */
@Repository
public interface HwCaseFileMapper extends BaseMapper<HwCaseFile> {

    @Select("Select F.*,C.F_PageName,C.F_UploadCheck,C.F_SiteSeq from(select F_MainId, F_FileId,F_PageCode,F_UploadFlag,F_FileSrc from HW_Case_File where F_MainId=#{param1}) F," +
            "HW_Case_FileConfig C where C.F_FileType=#{param2} and C.F_PageCode=F.F_PageCode Order by F_SiteSeq")
    List<Map<String, Object>> dyGetUserList( String  param1 ,String param2);
    @Select("Select F_UploadFlag,F_UploadCheck from(select F_FileId,F_PageCode,F_UploadFlag,F_FileSrc from HW_Case_File where F_MainId=#{param1}) " +
            "F,HW_Case_FileConfig C where C.F_FileType=#{param2} and C.F_PageCode=F.F_PageCode  and F_UploadCheck='1' ")
    List<Map<String, Object>> uploadingFinish( String  param1 ,String param2);

}
